home *** CD-ROM | disk | FTP | other *** search
/ Nebula 1 / Nebula One.iso / Misc / msql-1.0.6 / src / tests / rtest.src / 5.out < prev    next >
Text File  |  1995-01-04  |  2KB  |  83 lines
  1.  
  2. Welcome to the miniSQL monitor.  Type \h for help.
  3.  
  4.  
  5. mSQL >     -> 
  6. Query buffer
  7. ------------
  8.  
  9. select phone from test where user = 'Bambi'
  10. [continue]
  11.     -> 
  12. Query OK.
  13.  
  14. 1 rows matched.
  15.  
  16.  +----------------------+
  17.  | phone                |
  18.  +----------------------+
  19.  | (075) 951450         |
  20.  +----------------------+
  21.  
  22.  
  23.  
  24. mSQL >     -> 
  25. Query buffer
  26. ------------
  27. select * from test2 
  28. [continue]
  29.     -> 
  30. Query OK.
  31.  
  32. 3 rows matched.
  33.  
  34.  +------------+--------------------------------+
  35.  | user       | fullname                       |
  36.  +------------+--------------------------------+
  37.  | paulp      | Paul Pyyvaara                  |
  38.  | Bambi      | David J. Hughes                |
  39.  | fred       | Fred O'Niell                   |
  40.  +------------+--------------------------------+
  41.  
  42.  
  43.  
  44. mSQL >     -> 
  45. Query buffer
  46. ------------
  47. select * from test where phone = '(075) 951412' 
  48. [continue]
  49.     -> 
  50. Query OK.
  51.  
  52. 1 rows matched.
  53.  
  54.  +------------+----------+----------------------+
  55.  | user       | age      | phone                |
  56.  +------------+----------+----------------------+
  57.  | paulp      | 25       | (075) 951412         |
  58.  +------------+----------+----------------------+
  59.  
  60.  
  61.  
  62. mSQL >     -> 
  63. Query buffer
  64. ------------
  65. select * from test where user like '%am%' 
  66. [continue]
  67.     -> 
  68. Query OK.
  69.  
  70. 1 rows matched.
  71.  
  72.  +------------+----------+----------------------+
  73.  | user       | age      | phone                |
  74.  +------------+----------+----------------------+
  75.  | Bambi      | 26       | (075) 951450         |
  76.  +------------+----------+----------------------+
  77.  
  78.  
  79.  
  80. mSQL > 
  81. Bye!
  82.  
  83.